package com.xnsy.jishexiangmu.mapper;

import com.xnsy.jishexiangmu.pojo.School;
import com.xnsy.jishexiangmu.pojo.SchoolActive;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SchoolMapper {
    @Select("select * from xuexiao")
    List<School> get();
    @Select("select * from schoolactive")
    List<SchoolActive> getAll();
    @Select("select * from schoolactive where id = #{id}")
    SchoolActive getOne(Integer id);
    @Select("select * from xuexiao where id = #{id}")
    School getById(Integer id);
    @Select("select * from xuexiao where title like concat('%',#{name},'%')")
    List<School> getSome(String name);
}
